-- =============================================
-- Author:		Rodrigo Martins
-- Create date: 14/11/2013
-- Description:	Alterar Dieta
-- =============================================
CREATE PROCEDURE ai_sp_alterarDieta
	@id int output,
	@academia varchar(60),
	@cliente varchar (60),
	@funcionario varchar(60)
        @id_alimentacao int	

AS
BEGIN
	UPDATE DIETA
	SET academia = @dacademia 
	,cliente = @cliente
	,funcionario = @funcionario	
	     
	WHERE @id = id
END
GO
